Cartesian Product
- A Join is a predicate that attempts to combine 2 row sources. Cartesian Product is created when there are no join conditions between 2 row sources and there is no alternative method of accessing the data. Typically this is caused by a coding mistake where a join has been left out. The CARTESIAN keyword in the Explain Plan indicates this situation.
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 12.7.2016 11:59:39 [SDK_1481129979000]